{smcl}
{txt}{sf}{ul off}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\Benjamin Bagozzi\Dropbox\International Environmental Politics\Diplomacy Malaria\Replication Files\Tables_A3.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res} 7 Jan 2021, 11:05:57
{txt}
{com}. 
. *read-in directed dyadic malaria data
. use "MainMalariaDataset.dta"
{txt}
{com}. 
. *format variables and collapse by country 2
. generate malariasd=Lmalaria_interp_2_m 
{txt}(54,554 missing values generated)

{com}. collapse (mean) Lmalaria_interp_2_m (sd) malariasd, by(cowcode_2)
{txt}
{com}. 
. *organize data for table
. sort cowcode_2 
{txt}
{com}. merge cowcode_2 using cowcodeswithnames
{txt}{p}
(note: you are using old
{bf:merge} syntax; see
{bf:{help merge:[D] merge}} for new syntax)
{p_end}
{p 0 4 2}
variable{txt} cowcode_2
does not uniquely identify observations in
cowcodeswithnames.dta
{p_end}

{com}. drop if _merge==2
{txt}(23 observations deleted)

{com}. drop _merge stateabb cowcode_2
{txt}
{com}. sort statenme 
{txt}
{com}. drop if Lmalaria_interp_2_m==.
{txt}(34 observations deleted)

{com}. 
. *save results as a CSV for use in building Table. A.3
. export delimited using "countrystatsfortable.csv", replace
{res}{txt}(note: file countrystatsfortable.csv not found)
{txt}file countrystatsfortable.csv saved

{com}. 
. *close log file
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\Benjamin Bagozzi\Dropbox\International Environmental Politics\Diplomacy Malaria\Replication Files\Tables_A3.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res} 7 Jan 2021, 11:05:59
{txt}{.-}
{smcl}
{txt}{sf}{ul off}